-
Re: Formula for Lights
I think I got it. =IF(AND(OR([Preparer Status]@row = "Not Started", [Preparer Status]@row = "In Progress"), [Preparer Due Date]@row < TODAY()), "Red", IF(AND([Prepare…1 · -
Re: Auto Flag a row for Multiple Conditions
You could do a nested IF statement. For example: =IF(RAIDD@row = "Risk",1,IF(RAIDD@row = "Assumption",1,IF(RAIDD@row = "Issue",1,IF(RAIDD@row = "Dependency",1,…1 ·